from django.db import models

# Create your models here.
#研发效能评分
class ZtRdEfficiency(models.Model):
    id = models.IntegerField(primary_key=True)
    account = models.CharField(max_length=30)
    realname = models.CharField(max_length=100, db_index=True)
    dept = models.CharField(max_length=60, db_index=True)
    company = models.CharField(max_length=120)
    position = models.CharField(max_length=30)
    positionType = models.CharField(max_length=30, db_index=True)
    detail = models.TextField()
    score = models.IntegerField()
    positionRank = models.IntegerField()
    positionMaxRank = models.IntegerField()
    rank = models.IntegerField()
    maxRank = models.IntegerField()
    startDate = models.DateField()
    endDate = models.DateField(db_index=True)
    createDate = models.DateTimeField()
    version = models.IntegerField()
    latest = models.CharField(max_length=10, db_index=True)

    class Meta:
        db_table = 'zt_rdefficiency'


#研发效能评分规则
class ZtRdEfficiencyRule(models.Model):
    id = models.IntegerField(primary_key=True)
    type = models.CharField(max_length=30)
    rule = models.TextField()
    version = models.IntegerField()
    latest = models.CharField(max_length=10)

    class Meta:
        db_table = 'zt_rdefficiencyrule'